Hi,I haven't found the right answer, yet.Thats why I'm asking now.Does someone know how to hide a Subreport in List View already when deploying the Report with the use of BIDS(2005 Version)?We have a set of basic reports that are given to our customers, and all the time we need to manually hide the Subreports in the Report-Manager.If we could chose this option in BIDS, we wouldn't have to do this again and again.I would be very grateful for help.

Ifyour main report is deleted, the subreport will still function as a stand-alone, so it's really no different than any other stand-alone report. There is really no such thing asa "subreport only", so I don't think there is a way to automatically hide subreports.I just looked through Report Properties and did not see the hidden report setting. There is a Hidden column on the Catalog table in ReportServer, which I believe is set to 1 when the report is hidden in List View through the Report Manager but I can't seem to find how to set it through the report design.

I looked at the properties, too, and haven't found something that would fit my requirements, either.Because the Report is only hidden in List View there would not be any disadvantage in hiding it (by property) beforethe Deployment.I wonder why there is no property to hide the report automatically.Does anybody else has a solution to this problem?

I guess, you can always give DBAdmins (or whoever deploys the reports for you) the script to set the property. This way, they can run it when they deploy the report and won't have to do it manually. Still an extra step, though. I will keep looking but so far, I don't see it available through the design. use ReportServer update dbo.catalog set hidden = 1 where name = YourReportName'

Thanks, this will make it faster indeed.

You can keep your subreports in a different project which will deploy to a separate folder on the report server and then hide this folder in Report Manager. In the main report, you can modify the ReportName property for the subreport with a relative path, such as ../Subreport Folder/Subreport NameI think this will give you what you want.Paul Turley, Hitachi Consulting

Thanks for the fast answers, i guess this will work.

Note that setting the Hidden field to 1 does not seem to wotk in 2008 R2. The Hidden field seems to only hide the report in Tile View. If you view the folder in List View, then the folder will be listed, even if Hidden = 1.

We migrated from SSRS 2005 to SSRS 2008, and although subreports are hidden, users can still see that in the List View. this was not the case in 2005, and it is very annoying that the function is changed in 2008. Its not very helpful at all, the whole point of hidden is to hide the report from general users yet the drill down still works. Is there any update on this so that hidden reports are not visible to general users? Any help and guidance is highly appreciated. Best Regards,M. Nauman